Online-Academy
Look, Read, Understand, Apply

JDBC Drivers

Drivers to connect a Database

In Java, drivers used to connect a database are called JDBC Drivers. JDBC (Java Database Connectivity) is the standard API that allows Java applications to communicate with databases.

How JDBC Works (Simple Flow)

Java Application -> JDBC API (java.sql) -> JDBC Driver -> Database

A JDBC driver is a software component that:

  • Translates Java JDBC calls into database-specific protocol
  • Allows Java programs to connect, send SQL queries, and receive results from a database

Types of JDBC Drivers

Java defines four types of JDBC drivers.

Type 1: JDBC-ODBC Bridge Driver (Deprecated)
  • Uses ODBC to connect database
  • Requires ODBC driver installed on client machine
  • Very slow, platform dependent
Type 2: Native-API Driver
  • Uses database's native client libraries
  • Faster than Type 1
  • Platform dependent
  • Requires native software installation
Type 3: Network Protocol Driver
  • Uses middleware server
  • Java talks to middleware, middleware talks to DB
  • Platform independent
  • More complex setup
Type 4: Thin Driver (Most Common)
  • Pure Java
  • Directly communicates with database
  • Platform independent
  • Best performance